When do you separate databases? - Mailing list pgsql-novice

From Conrad Schuler
Subject When do you separate databases?
Date
Msg-id l03130302b6a657c82b5c@[192.168.0.3]
Whole thread Raw
Responses Re: When do you separate databases?  (Alfred Perlstein <bright@wintelcom.net>)
Re: When do you separate databases?  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-novice
Hi All,

I am managing a database design project.

It will database our entire website including:

images, articles, bibliography, ecommerce, membership in website, site
statistics, etc.

The 'lumper' team member says "let's make it all one giant database with
dozens and dozens of tables".

The 'splitter' team member says "let's make it many separate databases each
having fewer tables".

What are the advantages and disadvantages to 'lumping' all tables into one
database vs. 'splitting' into multiple databases with fewer tables?

Thanks,

Conrad

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Stay informed about the latest changes at masks.org,
sign up for the eNewsletter at:
<http://www.masks.org/about/form_mail/newsletter_subscribe.html>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

masks.org survives on your donations.
Please help by mailing a tax-deductible donation to:

masks.org
P.O. Box 12089
Olympia WA 98508
USA

Our website is at:
<http://www.masks.org/>




pgsql-novice by date:

Previous
From: info@i-developit.com
Date:
Subject: Re: General Database Design Text
Next
From: Alfred Perlstein
Date:
Subject: Re: When do you separate databases?